﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Default.Master" AutoEventWireup="true" CodeBehind="Podia.aspx.cs" Inherits="Project_mfa.WebForm4" %>

<asp:Content ID="headPodia" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="mainPodia" ContentPlaceHolderID="cphContent" runat="server">
        <div class="row">
            <div class="col col_16">
                <div class="col col_16">
                    <asp:GridView
                        ID="podiaGrid"
                        runat="server"
                        DataSourceID="EntityDataSourcePodiaGrid"
                        AutoGenerateSelectButton="True"
                        DataKeyNames="pod_id"
                        SelectedRowStyle-BackColor="#6755ab"
                        BackColor="#9B9CE1"
                        ForeColor="Snow"
                        BorderColor="LightPink"
                        HeaderStyle-BackColor="#d49c5f" AutoGenerateColumns="False" AllowPaging="True" AllowSorting="True">
                        <Columns>
                            <asp:BoundField DataField="pod_omschrijving" HeaderText="Stage" SortExpression="pod_omschrijving" />
                            <asp:BoundField DataField="pod_locatie" HeaderText="Stage location" SortExpression="pod_locatie" />
                        </Columns>
                        <HeaderStyle BackColor="#d49c5f"></HeaderStyle>

                        <SelectedRowStyle BackColor="#6755AB"></SelectedRowStyle>
                    </asp:GridView>
                    <asp:EntityDataSource ID="EntityDataSourcePodiaGrid" runat="server" ConnectionString="name=groep1_festivalsEntities" DefaultContainerName="groep1_festivalsEntities" EnableFlattening="False" EntitySetName="podia">
                    </asp:EntityDataSource>

                    <br />

                    <asp:GridView
                        ID="banGrid2"
                        runat="server"
                        DataSourceID="EntityDataSourceBands2"
                        AllowPaging="True"
                        PageSize="5"
                        BackColor="#9fbf74"
                        ForeColor="WhiteSmoke" AutoGenerateColumns="False" DataKeyNames="fest_id,band_id,datum,uur"
                        HeaderStyle-BackColor="#d49c5f"
                        AllowSorting="True">
                        <Columns>

                            <asp:BoundField DataField="band_naam" HeaderText="Name" SortExpression="band_naam" ReadOnly="True" />
                            <asp:BoundField DataField="fest_naam" HeaderText="Festival" SortExpression="fest_naam" />
                            <asp:BoundField DataField="datum" DataFormatString="{0:d}" HeaderText="Date" SortExpression="datum" ReadOnly="True" />
                            <asp:BoundField DataField="uur" HeaderText="Hour" ReadOnly="True" SortExpression="uur" />
                        </Columns>
                    </asp:GridView>
                    <asp:EntityDataSource AutoGenerateOrderByClause="true" CommandText="Select bandsperfestival.fest_id, bandsperfestival.pod_id, bandsperfestival.band_id, bandsperfestival.fest_id, festivals.fest_naam, bands.band_naam, bandsperfestival.datum, bandsperfestival.uur from festivals, bandsperfestival, bands, podia where bands.band_id = bandsperfestival.band_id and podia.pod_id = bandsperfestival.pod_id and bandsperfestival.fest_id = festivals.fest_id" AutoGenerateWhereClause="true" Where="" ID="EntityDataSourceBands2" runat="server" ConnectionString="name=groep1_festivalsEntities" DefaultContainerName="groep1_festivalsEntities" EnableFlattening="False">
                        <WhereParameters>
                            <asp:ControlParameter DefaultValue="-1" ControlID="podiaGrid" DbType="Int32" Name="pod_id" PropertyName="SelectedDataKey.values('pod_id')" />
                        </WhereParameters>
                        <OrderByParameters>
                            <asp:ControlParameter ControlID="banGrid2" DefaultValue="datum,uur" />
                        </OrderByParameters>
                    </asp:EntityDataSource>
                </div>
            </div>
        </div>
</asp:Content>
